home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vcbadjust.sql < prev    next >
Text File  |  2000-05-12  |  379b  |  13 lines
  1. /*
  2. collects adjustments for a cashbox ; outer join to ensure there is a record for 
  3. the next level  view
  4. */
  5. create or replace view vcbadjust as
  6. select sum(total_adjust) cb_adjust, 
  7.     cashboxtotals.cashbox_total_seq
  8. from adjustment , 
  9.     cashboxtotals
  10. where adjustment.cashbox_total_seq_num (+)= cashboxtotals.cashbox_total_seq
  11. group by cashboxtotals.cashbox_total_seq;
  12.  
  13.